﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ImportDataSet" targetNamespace="http://tempuri.org/ImportDataSet.xsd" xmlns:mstns="http://tempuri.org/ImportDataSet.xsd" xmlns="http://tempuri.org/ImportDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="BusinessDatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="BusinessDatabaseConnectionString (Web.config)" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.BusinessDatabaseConnectionString.ConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Role` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Role` (`Name`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Name, ID FROM Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Role` SET `Name` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContainerTableAdapter" GeneratorDataComponentClassName="ContainerTableAdapter" Name="Container" UserDataComponentName="ContainerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="Container" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Container` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Container` (`ContainerNumber`, `ArrivedAddress`, `ImportInfoID`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContainerNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContainerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArrivedAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArrivedAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ImportInfoID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportInfoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ContainerNumber, ArrivedAddress, ImportInfoID FROM [Container]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Container` SET `ContainerNumber` = ?, `ArrivedAddress` = ?, `ImportInfoID` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContainerNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContainerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArrivedAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArrivedAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ImportInfoID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportInfoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ContainerNumber" DataSetColumn="ContainerNumber" />
              <Mapping SourceColumn="ArrivedAddress" DataSetColumn="ArrivedAddress" />
              <Mapping SourceColumn="ImportInfoID" DataSetColumn="ImportInfoID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="Container" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillContainerByInfoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetContainerByInfoId" GeneratorSourceName="FillContainerByInfoId" GetMethodModifier="Public" GetMethodName="GetContainerByInfoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetContainerByInfoId" UserSourceName="FillContainerByInfoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM [Container] where ImportInfoID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ImportInfoID" DataSourceName="Container" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ImportInfoID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportInfoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImportInfoTableAdapter" GeneratorDataComponentClassName="ImportInfoTableAdapter" Name="ImportInfo" UserDataComponentName="ImportInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="ImportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ImportInfo` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ImportInfo` (`Code`, `CustomerCompany`, `CustomerName`, `CustomerPhone`, `ShipCompany`, `Voyage`, `BillNumber`, `ProductName`, `ProductWeight`, `ProductVolume`, `Port`, `Warehouse`, `ArrivedDate`, `LeaveDate`, `ExpiredDate`, `RecievedBillDate`, `ExchangeBillDate`, `ExchangeBillAddress`, `CheckNumber`, `EverythingReadyDate`, `BigPassDate`, `CustomDate`, `BoxSize`, `BoxNumber`, `CustomCompany`, `ManualNumber`, `OhterProveNumber`, `ContractNumber`, `LetPassDate`, `InvoiceDate`, `PortPlanDate`, `IsTransportFaster`, `DeliveryDate`, `TruckCompany`, `CheckDeclarationDate`, `CustomerNumber`, `Quantity`, `IsCompleted`, `ShipArrivedDate`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `Modifiedby`, `Remark`, `AnimalCheckNumber`, `DrawbackDeclarationDate`, `DrawbackTaxDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerPhone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ShipCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ShipCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Voyage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Voyage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BillNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductWeight" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductVolume" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductVolume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Port" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Port" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Warehouse" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Warehouse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ArrivedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ArrivedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LeaveDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LeaveDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ExpiredDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpiredDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="RecievedBillDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="RecievedBillDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ExchangeBillDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExchangeBillDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ExchangeBillAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ExchangeBillAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CheckNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CheckNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EverythingReadyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EverythingReadyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="BigPassDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="BigPassDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CustomDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CustomDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BoxSize" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BoxSize" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BoxNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BoxNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ManualNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ManualNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="OhterProveNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="OhterProveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContractNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContractNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LetPassDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LetPassDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="PortPlanDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PortPlanDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsTransportFaster" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsTransportFaster" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DeliveryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DeliveryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TruckCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TruckCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CheckDeclarationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CheckDeclarationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Quantity" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsCompleted" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCompleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ShipArrivedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ShipArrivedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Modifiedby" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Modifiedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Remark" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AnimalCheckNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AnimalCheckNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DrawbackDeclarationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrawbackDeclarationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DrawbackTaxDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrawbackTaxDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Code, CustomerCompany, CustomerName, CustomerPhone, ShipCompany, Voyage, BillNumber, ProductName, ProductWeight, ProductVolume, Port, Warehouse, ArrivedDate, LeaveDate, ExpiredDate, RecievedBillDate, ExchangeBillDate, ExchangeBillAddress, CheckNumber, EverythingReadyDate, BigPassDate, CustomDate, BoxSize, BoxNumber, CustomCompany, ManualNumber, OhterProveNumber, ContractNumber, LetPassDate, InvoiceDate, PortPlanDate, IsTransportFaster, DeliveryDate, TruckCompany, CheckDeclarationDate, CustomerNumber, Quantity, IsCompleted, ShipArrivedDate, CreatedDate, CreatedBy, ModifiedDate, Modifiedby, Remark, AnimalCheckNumber, DrawbackDeclarationDate, DrawbackTaxDate FROM ImportInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ImportInfo` SET `Code` = ?, `CustomerCompany` = ?, `CustomerName` = ?, `CustomerPhone` = ?, `ShipCompany` = ?, `Voyage` = ?, `BillNumber` = ?, `ProductName` = ?, `ProductWeight` = ?, `ProductVolume` = ?, `Port` = ?, `Warehouse` = ?, `ArrivedDate` = ?, `LeaveDate` = ?, `ExpiredDate` = ?, `RecievedBillDate` = ?, `ExchangeBillDate` = ?, `ExchangeBillAddress` = ?, `CheckNumber` = ?, `EverythingReadyDate` = ?, `BigPassDate` = ?, `CustomDate` = ?, `BoxSize` = ?, `BoxNumber` = ?, `CustomCompany` = ?, `ManualNumber` = ?, `OhterProveNumber` = ?, `ContractNumber` = ?, `LetPassDate` = ?, `InvoiceDate` = ?, `PortPlanDate` = ?, `IsTransportFaster` = ?, `DeliveryDate` = ?, `TruckCompany` = ?, `CheckDeclarationDate` = ?, `CustomerNumber` = ?, `Quantity` = ?, `IsCompleted` = ?, `ShipArrivedDate` = ?, `CreatedDate` = ?, `CreatedBy` = ?, `ModifiedDate` = ?, `Modifiedby` = ?, `Remark` = ?, `AnimalCheckNumber` = ?, `DrawbackDeclarationDate` = ?, `DrawbackTaxDate` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerPhone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ShipCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ShipCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Voyage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Voyage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BillNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductWeight" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProductVolume" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProductVolume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Port" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Port" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Warehouse" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Warehouse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ArrivedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ArrivedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LeaveDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LeaveDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ExpiredDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpiredDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="RecievedBillDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="RecievedBillDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ExchangeBillDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExchangeBillDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ExchangeBillAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ExchangeBillAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CheckNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CheckNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EverythingReadyDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EverythingReadyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="BigPassDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="BigPassDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CustomDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CustomDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BoxSize" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BoxSize" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BoxNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BoxNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ManualNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ManualNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="OhterProveNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="OhterProveNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContractNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContractNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LetPassDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LetPassDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="PortPlanDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="PortPlanDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsTransportFaster" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsTransportFaster" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DeliveryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DeliveryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TruckCompany" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TruckCompany" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CheckDeclarationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CheckDeclarationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Quantity" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsCompleted" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCompleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ShipArrivedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ShipArrivedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Modifiedby" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Modifiedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Remark" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AnimalCheckNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AnimalCheckNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DrawbackDeclarationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrawbackDeclarationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DrawbackTaxDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DrawbackTaxDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="CustomerCompany" DataSetColumn="CustomerCompany" />
              <Mapping SourceColumn="CustomerName" DataSetColumn="CustomerName" />
              <Mapping SourceColumn="CustomerPhone" DataSetColumn="CustomerPhone" />
              <Mapping SourceColumn="ShipCompany" DataSetColumn="ShipCompany" />
              <Mapping SourceColumn="Voyage" DataSetColumn="Voyage" />
              <Mapping SourceColumn="BillNumber" DataSetColumn="BillNumber" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="ProductWeight" DataSetColumn="ProductWeight" />
              <Mapping SourceColumn="ProductVolume" DataSetColumn="ProductVolume" />
              <Mapping SourceColumn="Port" DataSetColumn="Port" />
              <Mapping SourceColumn="Warehouse" DataSetColumn="Warehouse" />
              <Mapping SourceColumn="ArrivedDate" DataSetColumn="ArrivedDate" />
              <Mapping SourceColumn="LeaveDate" DataSetColumn="LeaveDate" />
              <Mapping SourceColumn="ExpiredDate" DataSetColumn="ExpiredDate" />
              <Mapping SourceColumn="RecievedBillDate" DataSetColumn="RecievedBillDate" />
              <Mapping SourceColumn="ExchangeBillDate" DataSetColumn="ExchangeBillDate" />
              <Mapping SourceColumn="ExchangeBillAddress" DataSetColumn="ExchangeBillAddress" />
              <Mapping SourceColumn="CheckNumber" DataSetColumn="CheckNumber" />
              <Mapping SourceColumn="EverythingReadyDate" DataSetColumn="EverythingReadyDate" />
              <Mapping SourceColumn="BigPassDate" DataSetColumn="BigPassDate" />
              <Mapping SourceColumn="CustomDate" DataSetColumn="CustomDate" />
              <Mapping SourceColumn="BoxSize" DataSetColumn="BoxSize" />
              <Mapping SourceColumn="BoxNumber" DataSetColumn="BoxNumber" />
              <Mapping SourceColumn="CustomCompany" DataSetColumn="CustomCompany" />
              <Mapping SourceColumn="ManualNumber" DataSetColumn="ManualNumber" />
              <Mapping SourceColumn="OhterProveNumber" DataSetColumn="OhterProveNumber" />
              <Mapping SourceColumn="ContractNumber" DataSetColumn="ContractNumber" />
              <Mapping SourceColumn="LetPassDate" DataSetColumn="LetPassDate" />
              <Mapping SourceColumn="InvoiceDate" DataSetColumn="InvoiceDate" />
              <Mapping SourceColumn="PortPlanDate" DataSetColumn="PortPlanDate" />
              <Mapping SourceColumn="IsTransportFaster" DataSetColumn="IsTransportFaster" />
              <Mapping SourceColumn="DeliveryDate" DataSetColumn="DeliveryDate" />
              <Mapping SourceColumn="TruckCompany" DataSetColumn="TruckCompany" />
              <Mapping SourceColumn="CheckDeclarationDate" DataSetColumn="CheckDeclarationDate" />
              <Mapping SourceColumn="CustomerNumber" DataSetColumn="CustomerNumber" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="IsCompleted" DataSetColumn="IsCompleted" />
              <Mapping SourceColumn="ShipArrivedDate" DataSetColumn="ShipArrivedDate" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="Modifiedby" DataSetColumn="Modifiedby" />
              <Mapping SourceColumn="Remark" DataSetColumn="Remark" />
              <Mapping SourceColumn="AnimalCheckNumber" DataSetColumn="AnimalCheckNumber" />
              <Mapping SourceColumn="DrawbackDeclarationDate" DataSetColumn="DrawbackDeclarationDate" />
              <Mapping SourceColumn="DrawbackTaxDate" DataSetColumn="DrawbackTaxDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByCondition" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCondition" GeneratorSourceName="FillByCondition" GetMethodModifier="Public" GetMethodName="GetDataByCondition" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCondition" UserSourceName="FillByCondition">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  i.*, u.Name AS UserName
FROM      (ImportInfo i INNER JOIN
                [User] u ON u.ID = i.CreatedBy)
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="ImportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillInfoById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetInfoById" GeneratorSourceName="FillInfoById" GetMethodModifier="Public" GetMethodName="GetInfoById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetInfoById" UserSourceName="FillInfoById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM ImportInfo where ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="ImportInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetInfoIDByCode" Modifier="Public" Name="GetInfoIDByCode" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetInfoIDByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Max(ID)
FROM ImportInfo
WHERE (Code LIKE ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Code" DataSourceName="ImportInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetUserImportCode" Modifier="Public" Name="GetUserImportCode" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetUserImportCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(Code) AS ImportMaxCode
FROM ImportInfo
WHERE (CreatedBy = ?) 
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="CreatedBy" DataSourceName="ImportInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeeTableAdapter" GeneratorDataComponentClassName="FeeTableAdapter" Name="Fee" UserDataComponentName="FeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="Fee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Fee` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Fee` (`ImportId`, `ExchangeFee1`, `ShippingFee1`, `ShippingFee2`, `CustomsFee1`, `CustomsFee2`, `BlockFee`, `InsuranceFee`, `TariffFee`, `LateFee`, `ThreeCheckFee`, `BoxCheckFee`, `ExaminationFee`, `DisinfectionFee`, `CustomsCheckFee`, `ArrangeProductFee`, `PortOtherFee`, `PutBoxFee`, `LeaveFee`, `ExpiredFee`, `BrokenBoxFee`, `ChangeBoxDoorFee`, `FumigationFee`, `KillBugFee`, `LeaseBoxFee`, `WarehouseFee`, `TransportFee1`, `TransportFee2`, `AnimalHealthCheckFee`, `AnimalBoxCheckFee`, `ClearBoxFee`, `ChangePlanFee`, `AgentFee`, `TypeBillFee`, `TakeBillFee`, `ExpressionFee`, `DoneFee`, `WaitingFee`, `InternalTransportFee`, `ExchangeBoxFee`, `FairEmployeeFee`, `CommissionFee`, `MoneyExchangeFee`, `Receiptable`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`, `ExchangeFee2`, `ExchangeFee3`, `OtherFee`, `PayFee`, `Profit`, `BookingFee`, `CertificationFee`, `DigitalPassFee`, `BuyCertificationFee`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ImportId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ShippingFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ShippingFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ShippingFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ShippingFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BlockFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BlockFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="InsuranceFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="InsuranceFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TariffFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TariffFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LateFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LateFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ThreeCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ThreeCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BoxCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BoxCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExaminationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExaminationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DisinfectionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DisinfectionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ArrangeProductFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ArrangeProductFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PortOtherFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PortOtherFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PutBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PutBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LeaveFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LeaveFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExpiredFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExpiredFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BrokenBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BrokenBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ChangeBoxDoorFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ChangeBoxDoorFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="FumigationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="FumigationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="KillBugFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KillBugFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LeaseBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LeaseBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="WarehouseFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="WarehouseFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TransportFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TransportFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TransportFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TransportFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AnimalHealthCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AnimalHealthCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AnimalBoxCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AnimalBoxCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ClearBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ClearBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ChangePlanFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ChangePlanFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AgentFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AgentFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TypeBillFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TypeBillFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TakeBillFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TakeBillFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExpressionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExpressionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DoneFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DoneFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="WaitingFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="WaitingFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="InternalTransportFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="InternalTransportFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="FairEmployeeFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="FairEmployeeFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CommissionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CommissionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="MoneyExchangeFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="MoneyExchangeFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Receiptable" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Receiptable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ModifiedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee3" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="OtherFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="OtherFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PayFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PayFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Profit" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Profit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BookingFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BookingFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CertificationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CertificationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DigitalPassFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DigitalPassFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BuyCertificationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BuyCertificationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, ImportId, ExchangeFee1, ShippingFee1, ShippingFee2, CustomsFee1, 
      CustomsFee2, BlockFee, InsuranceFee, TariffFee, LateFee, ThreeCheckFee, 
      BoxCheckFee, ExaminationFee, DisinfectionFee, CustomsCheckFee, 
      ArrangeProductFee, PortOtherFee, PutBoxFee, LeaveFee, ExpiredFee, BrokenBoxFee, 
      ChangeBoxDoorFee, FumigationFee, KillBugFee, LeaseBoxFee, WarehouseFee, 
      TransportFee1, TransportFee2, AnimalHealthCheckFee, AnimalBoxCheckFee, 
      ClearBoxFee, ChangePlanFee, AgentFee, TypeBillFee, TakeBillFee, ExpressionFee, 
      DoneFee, WaitingFee, InternalTransportFee, ExchangeBoxFee, FairEmployeeFee, 
      CommissionFee, MoneyExchangeFee, Receiptable, CreatedDate, CreatedBy, 
      ModifiedDate, ModifiedBy, ExchangeFee2, ExchangeFee3, OtherFee, PayFee, Profit, 
      BookingFee, CertificationFee, DigitalPassFee, BuyCertificationFee
FROM Fee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Fee` SET `ImportId` = ?, `ExchangeFee1` = ?, `ShippingFee1` = ?, `ShippingFee2` = ?, `CustomsFee1` = ?, `CustomsFee2` = ?, `BlockFee` = ?, `InsuranceFee` = ?, `TariffFee` = ?, `LateFee` = ?, `ThreeCheckFee` = ?, `BoxCheckFee` = ?, `ExaminationFee` = ?, `DisinfectionFee` = ?, `CustomsCheckFee` = ?, `ArrangeProductFee` = ?, `PortOtherFee` = ?, `PutBoxFee` = ?, `LeaveFee` = ?, `ExpiredFee` = ?, `BrokenBoxFee` = ?, `ChangeBoxDoorFee` = ?, `FumigationFee` = ?, `KillBugFee` = ?, `LeaseBoxFee` = ?, `WarehouseFee` = ?, `TransportFee1` = ?, `TransportFee2` = ?, `AnimalHealthCheckFee` = ?, `AnimalBoxCheckFee` = ?, `ClearBoxFee` = ?, `ChangePlanFee` = ?, `AgentFee` = ?, `TypeBillFee` = ?, `TakeBillFee` = ?, `ExpressionFee` = ?, `DoneFee` = ?, `WaitingFee` = ?, `InternalTransportFee` = ?, `ExchangeBoxFee` = ?, `FairEmployeeFee` = ?, `CommissionFee` = ?, `MoneyExchangeFee` = ?, `Receiptable` = ?, `CreatedDate` = ?, `CreatedBy` = ?, `ModifiedDate` = ?, `ModifiedBy` = ?, `ExchangeFee2` = ?, `ExchangeFee3` = ?, `OtherFee` = ?, `PayFee` = ?, `Profit` = ?, `BookingFee` = ?, `CertificationFee` = ?, `DigitalPassFee` = ?, `BuyCertificationFee` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ImportId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ShippingFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ShippingFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ShippingFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ShippingFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BlockFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BlockFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="InsuranceFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="InsuranceFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TariffFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TariffFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LateFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LateFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ThreeCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ThreeCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BoxCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BoxCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExaminationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExaminationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DisinfectionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DisinfectionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CustomsCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CustomsCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ArrangeProductFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ArrangeProductFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PortOtherFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PortOtherFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PutBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PutBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LeaveFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LeaveFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExpiredFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExpiredFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BrokenBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BrokenBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ChangeBoxDoorFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ChangeBoxDoorFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="FumigationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="FumigationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="KillBugFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KillBugFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="LeaseBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="LeaseBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="WarehouseFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="WarehouseFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TransportFee1" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TransportFee1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TransportFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TransportFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AnimalHealthCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AnimalHealthCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AnimalBoxCheckFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AnimalBoxCheckFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ClearBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ClearBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ChangePlanFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ChangePlanFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="AgentFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="AgentFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TypeBillFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TypeBillFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="TakeBillFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="TakeBillFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExpressionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExpressionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DoneFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DoneFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="WaitingFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="WaitingFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="InternalTransportFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="InternalTransportFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeBoxFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeBoxFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="FairEmployeeFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="FairEmployeeFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CommissionFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CommissionFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="MoneyExchangeFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="MoneyExchangeFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Receiptable" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Receiptable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ModifiedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee2" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ExchangeFee3" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="ExchangeFee3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="OtherFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="OtherFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PayFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="PayFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Profit" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Profit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BookingFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BookingFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CertificationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="CertificationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DigitalPassFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="DigitalPassFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="BuyCertificationFee" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="BuyCertificationFee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="ImportId" DataSetColumn="ImportId" />
              <Mapping SourceColumn="ExchangeFee1" DataSetColumn="ExchangeFee1" />
              <Mapping SourceColumn="ShippingFee1" DataSetColumn="ShippingFee1" />
              <Mapping SourceColumn="ShippingFee2" DataSetColumn="ShippingFee2" />
              <Mapping SourceColumn="CustomsFee1" DataSetColumn="CustomsFee1" />
              <Mapping SourceColumn="CustomsFee2" DataSetColumn="CustomsFee2" />
              <Mapping SourceColumn="BlockFee" DataSetColumn="BlockFee" />
              <Mapping SourceColumn="InsuranceFee" DataSetColumn="InsuranceFee" />
              <Mapping SourceColumn="TariffFee" DataSetColumn="TariffFee" />
              <Mapping SourceColumn="LateFee" DataSetColumn="LateFee" />
              <Mapping SourceColumn="ThreeCheckFee" DataSetColumn="ThreeCheckFee" />
              <Mapping SourceColumn="BoxCheckFee" DataSetColumn="BoxCheckFee" />
              <Mapping SourceColumn="ExaminationFee" DataSetColumn="ExaminationFee" />
              <Mapping SourceColumn="DisinfectionFee" DataSetColumn="DisinfectionFee" />
              <Mapping SourceColumn="CustomsCheckFee" DataSetColumn="CustomsCheckFee" />
              <Mapping SourceColumn="ArrangeProductFee" DataSetColumn="ArrangeProductFee" />
              <Mapping SourceColumn="PortOtherFee" DataSetColumn="PortOtherFee" />
              <Mapping SourceColumn="PutBoxFee" DataSetColumn="PutBoxFee" />
              <Mapping SourceColumn="LeaveFee" DataSetColumn="LeaveFee" />
              <Mapping SourceColumn="ExpiredFee" DataSetColumn="ExpiredFee" />
              <Mapping SourceColumn="BrokenBoxFee" DataSetColumn="BrokenBoxFee" />
              <Mapping SourceColumn="ChangeBoxDoorFee" DataSetColumn="ChangeBoxDoorFee" />
              <Mapping SourceColumn="FumigationFee" DataSetColumn="FumigationFee" />
              <Mapping SourceColumn="KillBugFee" DataSetColumn="KillBugFee" />
              <Mapping SourceColumn="LeaseBoxFee" DataSetColumn="LeaseBoxFee" />
              <Mapping SourceColumn="WarehouseFee" DataSetColumn="WarehouseFee" />
              <Mapping SourceColumn="TransportFee1" DataSetColumn="TransportFee1" />
              <Mapping SourceColumn="TransportFee2" DataSetColumn="TransportFee2" />
              <Mapping SourceColumn="AnimalHealthCheckFee" DataSetColumn="AnimalHealthCheckFee" />
              <Mapping SourceColumn="AnimalBoxCheckFee" DataSetColumn="AnimalBoxCheckFee" />
              <Mapping SourceColumn="ClearBoxFee" DataSetColumn="ClearBoxFee" />
              <Mapping SourceColumn="ChangePlanFee" DataSetColumn="ChangePlanFee" />
              <Mapping SourceColumn="AgentFee" DataSetColumn="AgentFee" />
              <Mapping SourceColumn="TypeBillFee" DataSetColumn="TypeBillFee" />
              <Mapping SourceColumn="TakeBillFee" DataSetColumn="TakeBillFee" />
              <Mapping SourceColumn="ExpressionFee" DataSetColumn="ExpressionFee" />
              <Mapping SourceColumn="DoneFee" DataSetColumn="DoneFee" />
              <Mapping SourceColumn="WaitingFee" DataSetColumn="WaitingFee" />
              <Mapping SourceColumn="InternalTransportFee" DataSetColumn="InternalTransportFee" />
              <Mapping SourceColumn="ExchangeBoxFee" DataSetColumn="ExchangeBoxFee" />
              <Mapping SourceColumn="FairEmployeeFee" DataSetColumn="FairEmployeeFee" />
              <Mapping SourceColumn="CommissionFee" DataSetColumn="CommissionFee" />
              <Mapping SourceColumn="MoneyExchangeFee" DataSetColumn="MoneyExchangeFee" />
              <Mapping SourceColumn="Receiptable" DataSetColumn="Receiptable" />
              <Mapping SourceColumn="ExchangeFee2" DataSetColumn="ExchangeFee2" />
              <Mapping SourceColumn="ExchangeFee3" DataSetColumn="ExchangeFee3" />
              <Mapping SourceColumn="OtherFee" DataSetColumn="OtherFee" />
              <Mapping SourceColumn="PayFee" DataSetColumn="PayFee" />
              <Mapping SourceColumn="Profit" DataSetColumn="Profit" />
              <Mapping SourceColumn="BookingFee" DataSetColumn="BookingFee" />
              <Mapping SourceColumn="CertificationFee" DataSetColumn="CertificationFee" />
              <Mapping SourceColumn="DigitalPassFee" DataSetColumn="DigitalPassFee" />
              <Mapping SourceColumn="BuyCertificationFee" DataSetColumn="BuyCertificationFee" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="Fee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillFeeByInfoId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetFeeByInfoId" GeneratorSourceName="FillFeeByInfoId" GetMethodModifier="Public" GetMethodName="GetFeeByInfoId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetFeeByInfoId" UserSourceName="FillFeeByInfoId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AgentFee, AnimalBoxCheckFee, AnimalHealthCheckFee, ArrangeProductFee, BlockFee, BookingFee, BoxCheckFee, BrokenBoxFee, BuyCertificationFee, CertificationFee, ChangeBoxDoorFee, ChangePlanFee, ClearBoxFee, CommissionFee, CreatedBy, CreatedDate, CustomsCheckFee, CustomsFee1, CustomsFee2, DigitalPassFee, DisinfectionFee, DoneFee, ExaminationFee, ExchangeBoxFee, ExchangeFee1, ExchangeFee2, ExchangeFee3, ExpiredFee, ExpressionFee, FairEmployeeFee, FumigationFee, ID, ImportId, InsuranceFee, InternalTransportFee, KillBugFee, LateFee, LeaseBoxFee, LeaveFee, ModifiedBy, ModifiedDate, MoneyExchangeFee, OtherFee, PayFee, PortOtherFee, Profit, PutBoxFee, Receiptable, ShippingFee1, ShippingFee2, TakeBillFee, TariffFee, ThreeCheckFee, TransportFee1, TransportFee2, TypeBillFee, WaitingFee, WarehouseFee FROM Fee WHERE (ImportId = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ImportId" DataSourceName="Fee" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ImportId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTableAdapter" GeneratorDataComponentClassName="UserTableAdapter" Name="User" UserDataComponentName="UserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="[User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `User` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `User` (`Code`, `Name`, `Telephone`, `Cellphone`, `QQ`, `MSN`, `Address`, `Gender`, `Passsword`, `RoleId`, `CreatedDate`, `CreatedBy`, `ModifiedDate`, `ModifiedBy`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Telephone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Cellphone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Cellphone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QQ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="MSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Gender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Passsword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Passsword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RoleId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ModifiedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Name, Telephone, Cellphone, QQ, MSN, Address, Gender, Passsword, RoleId, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy, ID FROM [User]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `User` SET `Code` = ?, `Name` = ?, `Telephone` = ?, `Cellphone` = ?, `QQ` = ?, `MSN` = ?, `Address` = ?, `Gender` = ?, `Passsword` = ?, `RoleId` = ?, `CreatedDate` = ?, `CreatedBy` = ?, `ModifiedDate` = ?, `ModifiedBy` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Telephone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Cellphone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Cellphone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QQ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="QQ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="MSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Gender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Passsword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Passsword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RoleId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="CreatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CreatedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ModifiedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ModifiedBy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Telephone" DataSetColumn="Telephone" />
              <Mapping SourceColumn="Cellphone" DataSetColumn="Cellphone" />
              <Mapping SourceColumn="QQ" DataSetColumn="QQ" />
              <Mapping SourceColumn="MSN" DataSetColumn="MSN" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
              <Mapping SourceColumn="Passsword" DataSetColumn="Passsword" />
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectName="[User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillUserByCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserByCode" GeneratorSourceName="FillUserByCode" GetMethodModifier="Public" GetMethodName="GetUserByCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserByCode" UserSourceName="FillUserByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Code, Name, Telephone, Cellphone, QQ, MSN, Address, Gender, Passsword, RoleId, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy, ID FROM [User] WHERE (Code = ?) AND (Passsword = ?)

</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="Code" DataSourceName="[User]" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Passsword" DataSourceName="[User]" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Passsword" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Passsword" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillUserById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUserById" GeneratorSourceName="FillUserById" GetMethodModifier="Public" GetMethodName="GetUserById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUserById" UserSourceName="FillUserById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT u.*, r.name as RoleName FROM [User] u
inner join [Role] r on r.id = u.roleid
 where u.ID = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="[User]" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BusinessDatabaseConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillUsersWithRole" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetUsersWithRole" GeneratorSourceName="FillUsersWithRole" GetMethodModifier="Public" GetMethodName="GetUsersWithRole" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetUsersWithRole" UserSourceName="FillUsersWithRole">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT u.*, r.Name as RoleName FROM [User] u inner join [Role] r on r.id = u.roleid</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ImportDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="ImportDataSet" msprop:Generator_UserDSName="ImportDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Role" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole" msprop:Generator_TablePropName="Role" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_UserTableName="Role" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowClassName="RoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Container" msprop:Generator_TableClassName="ContainerDataTable" msprop:Generator_TableVarName="tableContainer" msprop:Generator_TablePropName="Container" msprop:Generator_RowDeletingName="ContainerRowDeleting" msprop:Generator_UserTableName="Container" msprop:Generator_RowChangingName="ContainerRowChanging" msprop:Generator_RowEvHandlerName="ContainerRowChangeEventHandler" msprop:Generator_RowDeletedName="ContainerRowDeleted" msprop:Generator_RowEvArgName="ContainerRowChangeEvent" msprop:Generator_RowChangedName="ContainerRowChanged" msprop:Generator_RowClassName="ContainerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ContainerNumber" msprop:Generator_ColumnVarNameInTable="columnContainerNumber" msprop:Generator_ColumnPropNameInRow="ContainerNumber" msprop:Generator_ColumnPropNameInTable="ContainerNumberColumn" msprop:Generator_UserColumnName="ContainerNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArrivedAddress" msprop:Generator_ColumnVarNameInTable="columnArrivedAddress" msprop:Generator_ColumnPropNameInRow="ArrivedAddress" msprop:Generator_ColumnPropNameInTable="ArrivedAddressColumn" msprop:Generator_UserColumnName="ArrivedAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ImportInfoID" msprop:Generator_ColumnVarNameInTable="columnImportInfoID" msprop:Generator_ColumnPropNameInRow="ImportInfoID" msprop:Generator_ColumnPropNameInTable="ImportInfoIDColumn" msprop:Generator_UserColumnName="ImportInfoID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ImportInfo" msprop:Generator_TableClassName="ImportInfoDataTable" msprop:Generator_TableVarName="tableImportInfo" msprop:Generator_TablePropName="ImportInfo" msprop:Generator_RowDeletingName="ImportInfoRowDeleting" msprop:Generator_UserTableName="ImportInfo" msprop:Generator_RowChangingName="ImportInfoRowChanging" msprop:Generator_RowEvHandlerName="ImportInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="ImportInfoRowDeleted" msprop:Generator_RowEvArgName="ImportInfoRowChangeEvent" msprop:Generator_RowChangedName="ImportInfoRowChanged" msprop:Generator_RowClassName="ImportInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msdata:Caption="全部" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Code" msdata:Caption="编号" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomerCompany" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnCustomerCompany" msprop:Generator_ColumnPropNameInRow="CustomerCompany" msprop:Generator_ColumnPropNameInTable="CustomerCompanyColumn" msprop:Generator_UserColumnName="CustomerCompany" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomerName" msdata:Caption="货主" msprop:Generator_ColumnVarNameInTable="columnCustomerName" msprop:Generator_ColumnPropNameInRow="CustomerName" msprop:Generator_ColumnPropNameInTable="CustomerNameColumn" msprop:Generator_UserColumnName="CustomerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomerPhone" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnCustomerPhone" msprop:Generator_ColumnPropNameInRow="CustomerPhone" msprop:Generator_ColumnPropNameInTable="CustomerPhoneColumn" msprop:Generator_UserColumnName="CustomerPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipCompany" msdata:Caption="船公司" msprop:Generator_ColumnVarNameInTable="columnShipCompany" msprop:Generator_ColumnPropNameInRow="ShipCompany" msprop:Generator_ColumnPropNameInTable="ShipCompanyColumn" msprop:Generator_UserColumnName="ShipCompany" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Voyage" msdata:Caption="船名航次" msprop:Generator_ColumnVarNameInTable="columnVoyage" msprop:Generator_ColumnPropNameInRow="Voyage" msprop:Generator_ColumnPropNameInTable="VoyageColumn" msprop:Generator_UserColumnName="Voyage" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillNumber" msdata:Caption="提单号" msprop:Generator_ColumnVarNameInTable="columnBillNumber" msprop:Generator_ColumnPropNameInRow="BillNumber" msprop:Generator_ColumnPropNameInTable="BillNumberColumn" msprop:Generator_UserColumnName="BillNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msdata:Caption="品名" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductWeight" msdata:Caption="重量" msprop:Generator_ColumnVarNameInTable="columnProductWeight" msprop:Generator_ColumnPropNameInRow="ProductWeight" msprop:Generator_ColumnPropNameInTable="ProductWeightColumn" msprop:Generator_UserColumnName="ProductWeight" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductVolume" msdata:Caption="体积" msprop:Generator_ColumnVarNameInTable="columnProductVolume" msprop:Generator_ColumnPropNameInRow="ProductVolume" msprop:Generator_ColumnPropNameInTable="ProductVolumeColumn" msprop:Generator_UserColumnName="ProductVolume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Port" msdata:Caption="港区" msprop:Generator_ColumnVarNameInTable="columnPort" msprop:Generator_ColumnPropNameInRow="Port" msprop:Generator_ColumnPropNameInTable="PortColumn" msprop:Generator_UserColumnName="Port" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Warehouse" msdata:Caption="仓库" msprop:Generator_ColumnVarNameInTable="columnWarehouse" msprop:Generator_ColumnPropNameInRow="Warehouse" msprop:Generator_ColumnPropNameInTable="WarehouseColumn" msprop:Generator_UserColumnName="Warehouse" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArrivedDate" msdata:Caption="到港日" msprop:Generator_ColumnVarNameInTable="columnArrivedDate" msprop:Generator_ColumnPropNameInRow="ArrivedDate" msprop:Generator_ColumnPropNameInTable="ArrivedDateColumn" msprop:Generator_UserColumnName="ArrivedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LeaveDate" msdata:Caption="疏港日" msprop:Generator_ColumnVarNameInTable="columnLeaveDate" msprop:Generator_ColumnPropNameInRow="LeaveDate" msprop:Generator_ColumnPropNameInTable="LeaveDateColumn" msprop:Generator_UserColumnName="LeaveDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ExpiredDate" msdata:Caption="超期日" msprop:Generator_ColumnVarNameInTable="columnExpiredDate" msprop:Generator_ColumnPropNameInRow="ExpiredDate" msprop:Generator_ColumnPropNameInTable="ExpiredDateColumn" msprop:Generator_UserColumnName="ExpiredDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RecievedBillDate" msdata:Caption="接单日" msprop:Generator_ColumnVarNameInTable="columnRecievedBillDate" msprop:Generator_ColumnPropNameInRow="RecievedBillDate" msprop:Generator_ColumnPropNameInTable="RecievedBillDateColumn" msprop:Generator_UserColumnName="RecievedBillDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ExchangeBillDate" msdata:Caption="换单日" msprop:Generator_ColumnVarNameInTable="columnExchangeBillDate" msprop:Generator_ColumnPropNameInRow="ExchangeBillDate" msprop:Generator_ColumnPropNameInTable="ExchangeBillDateColumn" msprop:Generator_UserColumnName="ExchangeBillDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ExchangeBillAddress" msdata:Caption="换单地" msprop:Generator_ColumnVarNameInTable="columnExchangeBillAddress" msprop:Generator_ColumnPropNameInRow="ExchangeBillAddress" msprop:Generator_ColumnPropNameInTable="ExchangeBillAddressColumn" msprop:Generator_UserColumnName="ExchangeBillAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckNumber" msdata:Caption="押支票号码" msprop:Generator_ColumnVarNameInTable="columnCheckNumber" msprop:Generator_ColumnPropNameInRow="CheckNumber" msprop:Generator_ColumnPropNameInTable="CheckNumberColumn" msprop:Generator_UserColumnName="CheckNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EverythingReadyDate" msdata:Caption="单证齐全日" msprop:Generator_ColumnVarNameInTable="columnEverythingReadyDate" msprop:Generator_ColumnPropNameInRow="EverythingReadyDate" msprop:Generator_ColumnPropNameInTable="EverythingReadyDateColumn" msprop:Generator_UserColumnName="EverythingReadyDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BigPassDate" msdata:Caption="大通关日" msprop:Generator_ColumnVarNameInTable="columnBigPassDate" msprop:Generator_ColumnPropNameInRow="BigPassDate" msprop:Generator_ColumnPropNameInTable="BigPassDateColumn" msprop:Generator_UserColumnName="BigPassDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CustomDate" msdata:Caption="报关日" msprop:Generator_ColumnVarNameInTable="columnCustomDate" msprop:Generator_ColumnPropNameInRow="CustomDate" msprop:Generator_ColumnPropNameInTable="CustomDateColumn" msprop:Generator_UserColumnName="CustomDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BoxSize" msdata:Caption="箱量" msprop:Generator_ColumnVarNameInTable="columnBoxSize" msprop:Generator_ColumnPropNameInRow="BoxSize" msprop:Generator_ColumnPropNameInTable="BoxSizeColumn" msprop:Generator_UserColumnName="BoxSize" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BoxNumber" msdata:Caption="条形码" msprop:Generator_ColumnVarNameInTable="columnBoxNumber" msprop:Generator_ColumnPropNameInRow="BoxNumber" msprop:Generator_ColumnPropNameInTable="BoxNumberColumn" msprop:Generator_UserColumnName="BoxNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomCompany" msdata:Caption="报关公司" msprop:Generator_ColumnVarNameInTable="columnCustomCompany" msprop:Generator_ColumnPropNameInRow="CustomCompany" msprop:Generator_ColumnPropNameInTable="CustomCompanyColumn" msprop:Generator_UserColumnName="CustomCompany" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManualNumber" msdata:Caption="手册号码" msprop:Generator_ColumnVarNameInTable="columnManualNumber" msprop:Generator_ColumnPropNameInRow="ManualNumber" msprop:Generator_ColumnPropNameInTable="ManualNumberColumn" msprop:Generator_UserColumnName="ManualNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OhterProveNumber" msdata:Caption="其它证明号码" msprop:Generator_ColumnVarNameInTable="columnOhterProveNumber" msprop:Generator_ColumnPropNameInRow="OhterProveNumber" msprop:Generator_ColumnPropNameInTable="OhterProveNumberColumn" msprop:Generator_UserColumnName="OhterProveNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContractNumber" msdata:Caption="外贸合同号" msprop:Generator_ColumnVarNameInTable="columnContractNumber" msprop:Generator_ColumnPropNameInRow="ContractNumber" msprop:Generator_ColumnPropNameInTable="ContractNumberColumn" msprop:Generator_UserColumnName="ContractNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LetPassDate" msdata:Caption="放行日" msprop:Generator_ColumnVarNameInTable="columnLetPassDate" msprop:Generator_ColumnPropNameInRow="LetPassDate" msprop:Generator_ColumnPropNameInTable="LetPassDateColumn" msprop:Generator_UserColumnName="LetPassDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="InvoiceDate" msdata:Caption="开票日期" msprop:Generator_ColumnVarNameInTable="columnInvoiceDate" msprop:Generator_ColumnPropNameInRow="InvoiceDate" msprop:Generator_ColumnPropNameInTable="InvoiceDateColumn" msprop:Generator_UserColumnName="InvoiceDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PortPlanDate" msdata:Caption="港区计划日" msprop:Generator_ColumnVarNameInTable="columnPortPlanDate" msprop:Generator_ColumnPropNameInRow="PortPlanDate" msprop:Generator_ColumnPropNameInTable="PortPlanDateColumn" msprop:Generator_UserColumnName="PortPlanDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IsTransportFaster" msdata:Caption="运输加急" msprop:Generator_ColumnVarNameInTable="columnIsTransportFaster" msprop:Generator_ColumnPropNameInRow="IsTransportFaster" msprop:Generator_ColumnPropNameInTable="IsTransportFasterColumn" msprop:Generator_UserColumnName="IsTransportFaster" type="xs:boolean" minOccurs="0" />
              <xs:element name="DeliveryDate" msdata:Caption="送货日" msprop:Generator_ColumnVarNameInTable="columnDeliveryDate" msprop:Generator_ColumnPropNameInRow="DeliveryDate" msprop:Generator_ColumnPropNameInTable="DeliveryDateColumn" msprop:Generator_UserColumnName="DeliveryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TruckCompany" msdata:Caption="车队" msprop:Generator_ColumnVarNameInTable="columnTruckCompany" msprop:Generator_ColumnPropNameInRow="TruckCompany" msprop:Generator_ColumnPropNameInTable="TruckCompanyColumn" msprop:Generator_UserColumnName="TruckCompany" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckDeclarationDate" msdata:Caption="核报关单日" msprop:Generator_ColumnVarNameInTable="columnCheckDeclarationDate" msprop:Generator_ColumnPropNameInRow="CheckDeclarationDate" msprop:Generator_ColumnPropNameInTable="CheckDeclarationDateColumn" msprop:Generator_UserColumnName="CheckDeclarationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CustomerNumber" msdata:Caption="客户编号" msprop:Generator_ColumnVarNameInTable="columnCustomerNumber" msprop:Generator_ColumnPropNameInRow="CustomerNumber" msprop:Generator_ColumnPropNameInTable="CustomerNumberColumn" msprop:Generator_UserColumnName="CustomerNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity" msdata:Caption="件数" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsCompleted" msdata:Caption="完成" msprop:Generator_ColumnVarNameInTable="columnIsCompleted" msprop:Generator_ColumnPropNameInRow="IsCompleted" msprop:Generator_ColumnPropNameInTable="IsCompletedColumn" msprop:Generator_UserColumnName="IsCompleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="ShipArrivedDate" msdata:Caption="预计到船日期" msprop:Generator_ColumnVarNameInTable="columnShipArrivedDate" msprop:Generator_ColumnPropNameInRow="ShipArrivedDate" msprop:Generator_ColumnPropNameInTable="ShipArrivedDateColumn" msprop:Generator_UserColumnName="ShipArrivedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreatedDate" msdata:Caption="录入时间" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreatedBy" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" msprop:Generator_UserColumnName="CreatedBy" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" msprop:Generator_UserColumnName="ModifiedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Modifiedby" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnModifiedby" msprop:Generator_ColumnPropNameInRow="Modifiedby" msprop:Generator_ColumnPropNameInTable="ModifiedbyColumn" msprop:Generator_UserColumnName="Modifiedby" type="xs:int" minOccurs="0" />
              <xs:element name="Remark" msdata:Caption="备注" msprop:Generator_ColumnVarNameInTable="columnRemark" msprop:Generator_ColumnPropNameInRow="Remark" msprop:Generator_ColumnPropNameInTable="RemarkColumn" msprop:Generator_UserColumnName="Remark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnimalCheckNumber" msdata:Caption="卫动编号" msprop:Generator_ColumnVarNameInTable="columnAnimalCheckNumber" msprop:Generator_ColumnPropNameInRow="AnimalCheckNumber" msprop:Generator_ColumnPropNameInTable="AnimalCheckNumberColumn" msprop:Generator_UserColumnName="AnimalCheckNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DrawbackDeclarationDate" msdata:Caption="退报关单日" msprop:Generator_ColumnVarNameInTable="columnDrawbackDeclarationDate" msprop:Generator_ColumnPropNameInRow="DrawbackDeclarationDate" msprop:Generator_ColumnPropNameInTable="DrawbackDeclarationDateColumn" msprop:Generator_UserColumnName="DrawbackDeclarationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DrawbackTaxDate" msdata:Caption="退税日" msprop:Generator_ColumnVarNameInTable="columnDrawbackTaxDate" msprop:Generator_ColumnPropNameInRow="DrawbackTaxDate" msprop:Generator_ColumnPropNameInTable="DrawbackTaxDateColumn" msprop:Generator_UserColumnName="DrawbackTaxDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UserName" msdata:Caption="录入人" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Fee" msprop:Generator_TableClassName="FeeDataTable" msprop:Generator_TableVarName="tableFee" msprop:Generator_TablePropName="Fee" msprop:Generator_RowDeletingName="FeeRowDeleting" msprop:Generator_UserTableName="Fee" msprop:Generator_RowChangingName="FeeRowChanging" msprop:Generator_RowEvHandlerName="FeeRowChangeEventHandler" msprop:Generator_RowDeletedName="FeeRowDeleted" msprop:Generator_RowEvArgName="FeeRowChangeEvent" msprop:Generator_RowChangedName="FeeRowChanged" msprop:Generator_RowClassName="FeeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ImportId" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnImportId" msprop:Generator_ColumnPropNameInRow="ImportId" msprop:Generator_ColumnPropNameInTable="ImportIdColumn" msprop:Generator_UserColumnName="ImportId" type="xs:int" minOccurs="0" />
              <xs:element name="ExchangeFee1" msdata:Caption="换单费1" msprop:Generator_ColumnVarNameInTable="columnExchangeFee1" msprop:Generator_ColumnPropNameInRow="ExchangeFee1" msprop:Generator_ColumnPropNameInTable="ExchangeFee1Column" msprop:Generator_UserColumnName="ExchangeFee1" type="xs:decimal" minOccurs="0" />
              <xs:element name="ShippingFee1" msdata:Caption="海运费1" msprop:Generator_ColumnVarNameInTable="columnShippingFee1" msprop:Generator_ColumnPropNameInRow="ShippingFee1" msprop:Generator_ColumnPropNameInTable="ShippingFee1Column" msprop:Generator_UserColumnName="ShippingFee1" type="xs:decimal" minOccurs="0" />
              <xs:element name="ShippingFee2" msdata:Caption="海运费2" msprop:Generator_ColumnVarNameInTable="columnShippingFee2" msprop:Generator_ColumnPropNameInRow="ShippingFee2" msprop:Generator_ColumnPropNameInTable="ShippingFee2Column" msprop:Generator_UserColumnName="ShippingFee2" type="xs:decimal" minOccurs="0" />
              <xs:element name="CustomsFee1" msdata:Caption="报关费1" msprop:Generator_ColumnVarNameInTable="columnCustomsFee1" msprop:Generator_ColumnPropNameInRow="CustomsFee1" msprop:Generator_ColumnPropNameInTable="CustomsFee1Column" msprop:Generator_UserColumnName="CustomsFee1" type="xs:decimal" minOccurs="0" />
              <xs:element name="CustomsFee2" msdata:Caption="报关费2" msprop:Generator_ColumnVarNameInTable="columnCustomsFee2" msprop:Generator_ColumnPropNameInRow="CustomsFee2" msprop:Generator_ColumnPropNameInTable="CustomsFee2Column" msprop:Generator_UserColumnName="CustomsFee2" type="xs:decimal" minOccurs="0" />
              <xs:element name="BlockFee" msdata:Caption="滞报金" msprop:Generator_ColumnVarNameInTable="columnBlockFee" msprop:Generator_ColumnPropNameInRow="BlockFee" msprop:Generator_ColumnPropNameInTable="BlockFeeColumn" msprop:Generator_UserColumnName="BlockFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="InsuranceFee" msdata:Caption="保证金" msprop:Generator_ColumnVarNameInTable="columnInsuranceFee" msprop:Generator_ColumnPropNameInRow="InsuranceFee" msprop:Generator_ColumnPropNameInTable="InsuranceFeeColumn" msprop:Generator_UserColumnName="InsuranceFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="TariffFee" msdata:Caption="税费" msprop:Generator_ColumnVarNameInTable="columnTariffFee" msprop:Generator_ColumnPropNameInRow="TariffFee" msprop:Generator_ColumnPropNameInTable="TariffFeeColumn" msprop:Generator_UserColumnName="TariffFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="LateFee" msdata:Caption="滞纳金" msprop:Generator_ColumnVarNameInTable="columnLateFee" msprop:Generator_ColumnPropNameInRow="LateFee" msprop:Generator_ColumnPropNameInTable="LateFeeColumn" msprop:Generator_UserColumnName="LateFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ThreeCheckFee" msdata:Caption="三检费" msprop:Generator_ColumnVarNameInTable="columnThreeCheckFee" msprop:Generator_ColumnPropNameInRow="ThreeCheckFee" msprop:Generator_ColumnPropNameInTable="ThreeCheckFeeColumn" msprop:Generator_UserColumnName="ThreeCheckFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="BoxCheckFee" msdata:Caption="箱检费" msprop:Generator_ColumnVarNameInTable="columnBoxCheckFee" msprop:Generator_ColumnPropNameInRow="BoxCheckFee" msprop:Generator_ColumnPropNameInTable="BoxCheckFeeColumn" msprop:Generator_UserColumnName="BoxCheckFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ExaminationFee" msdata:Caption="商检费" msprop:Generator_ColumnVarNameInTable="columnExaminationFee" msprop:Generator_ColumnPropNameInRow="ExaminationFee" msprop:Generator_ColumnPropNameInTable="ExaminationFeeColumn" msprop:Generator_UserColumnName="ExaminationFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="DisinfectionFee" msdata:Caption="消毒费" msprop:Generator_ColumnVarNameInTable="columnDisinfectionFee" msprop:Generator_ColumnPropNameInRow="DisinfectionFee" msprop:Generator_ColumnPropNameInTable="DisinfectionFeeColumn" msprop:Generator_UserColumnName="DisinfectionFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="CustomsCheckFee" msdata:Caption="海关查验" msprop:Generator_ColumnVarNameInTable="columnCustomsCheckFee" msprop:Generator_ColumnPropNameInRow="CustomsCheckFee" msprop:Generator_ColumnPropNameInTable="CustomsCheckFeeColumn" msprop:Generator_UserColumnName="CustomsCheckFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ArrangeProductFee" msdata:Caption="理货费" msprop:Generator_ColumnVarNameInTable="columnArrangeProductFee" msprop:Generator_ColumnPropNameInRow="ArrangeProductFee" msprop:Generator_ColumnPropNameInTable="ArrangeProductFeeColumn" msprop:Generator_UserColumnName="ArrangeProductFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="PortOtherFee" msdata:Caption="港杂港" msprop:Generator_ColumnVarNameInTable="columnPortOtherFee" msprop:Generator_ColumnPropNameInRow="PortOtherFee" msprop:Generator_ColumnPropNameInTable="PortOtherFeeColumn" msprop:Generator_UserColumnName="PortOtherFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="PutBoxFee" msdata:Caption="放箱费" msprop:Generator_ColumnVarNameInTable="columnPutBoxFee" msprop:Generator_ColumnPropNameInRow="PutBoxFee" msprop:Generator_ColumnPropNameInTable="PutBoxFeeColumn" msprop:Generator_UserColumnName="PutBoxFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="LeaveFee" msdata:Caption="疏港费" msprop:Generator_ColumnVarNameInTable="columnLeaveFee" msprop:Generator_ColumnPropNameInRow="LeaveFee" msprop:Generator_ColumnPropNameInTable="LeaveFeeColumn" msprop:Generator_UserColumnName="LeaveFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ExpiredFee" msdata:Caption="超期费" msprop:Generator_ColumnVarNameInTable="columnExpiredFee" msprop:Generator_ColumnPropNameInRow="ExpiredFee" msprop:Generator_ColumnPropNameInTable="ExpiredFeeColumn" msprop:Generator_UserColumnName="ExpiredFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="BrokenBoxFee" msdata:Caption="坏/污箱费" msprop:Generator_ColumnVarNameInTable="columnBrokenBoxFee" msprop:Generator_ColumnPropNameInRow="BrokenBoxFee" msprop:Generator_ColumnPropNameInTable="BrokenBoxFeeColumn" msprop:Generator_UserColumnName="BrokenBoxFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChangeBoxDoorFee" msdata:Caption="换箱门费" msprop:Generator_ColumnVarNameInTable="columnChangeBoxDoorFee" msprop:Generator_ColumnPropNameInRow="ChangeBoxDoorFee" msprop:Generator_ColumnPropNameInTable="ChangeBoxDoorFeeColumn" msprop:Generator_UserColumnName="ChangeBoxDoorFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="FumigationFee" msdata:Caption="熏蒸费" msprop:Generator_ColumnVarNameInTable="columnFumigationFee" msprop:Generator_ColumnPropNameInRow="FumigationFee" msprop:Generator_ColumnPropNameInTable="FumigationFeeColumn" msprop:Generator_UserColumnName="FumigationFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="KillBugFee" msdata:Caption="杀虫费" msprop:Generator_ColumnVarNameInTable="columnKillBugFee" msprop:Generator_ColumnPropNameInRow="KillBugFee" msprop:Generator_ColumnPropNameInTable="KillBugFeeColumn" msprop:Generator_UserColumnName="KillBugFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="LeaseBoxFee" msdata:Caption="落/留箱费" msprop:Generator_ColumnVarNameInTable="columnLeaseBoxFee" msprop:Generator_ColumnPropNameInRow="LeaseBoxFee" msprop:Generator_ColumnPropNameInTable="LeaseBoxFeeColumn" msprop:Generator_UserColumnName="LeaseBoxFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="WarehouseFee" msdata:Caption="仓储费" msprop:Generator_ColumnVarNameInTable="columnWarehouseFee" msprop:Generator_ColumnPropNameInRow="WarehouseFee" msprop:Generator_ColumnPropNameInTable="WarehouseFeeColumn" msprop:Generator_UserColumnName="WarehouseFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="TransportFee1" msdata:Caption="运输费1" msprop:Generator_ColumnVarNameInTable="columnTransportFee1" msprop:Generator_ColumnPropNameInRow="TransportFee1" msprop:Generator_ColumnPropNameInTable="TransportFee1Column" msprop:Generator_UserColumnName="TransportFee1" type="xs:decimal" minOccurs="0" />
              <xs:element name="TransportFee2" msdata:Caption="运输费2" msprop:Generator_ColumnVarNameInTable="columnTransportFee2" msprop:Generator_ColumnPropNameInRow="TransportFee2" msprop:Generator_ColumnPropNameInTable="TransportFee2Column" msprop:Generator_UserColumnName="TransportFee2" type="xs:decimal" minOccurs="0" />
              <xs:element name="AnimalHealthCheckFee" msdata:Caption="动卫查验" msprop:Generator_ColumnVarNameInTable="columnAnimalHealthCheckFee" msprop:Generator_ColumnPropNameInRow="AnimalHealthCheckFee" msprop:Generator_ColumnPropNameInTable="AnimalHealthCheckFeeColumn" msprop:Generator_UserColumnName="AnimalHealthCheckFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="AnimalBoxCheckFee" msdata:Caption="动检落箱费" msprop:Generator_ColumnVarNameInTable="columnAnimalBoxCheckFee" msprop:Generator_ColumnPropNameInRow="AnimalBoxCheckFee" msprop:Generator_ColumnPropNameInTable="AnimalBoxCheckFeeColumn" msprop:Generator_UserColumnName="AnimalBoxCheckFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ClearBoxFee" msdata:Caption="掏箱费" msprop:Generator_ColumnVarNameInTable="columnClearBoxFee" msprop:Generator_ColumnPropNameInRow="ClearBoxFee" msprop:Generator_ColumnPropNameInTable="ClearBoxFeeColumn" msprop:Generator_UserColumnName="ClearBoxFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChangePlanFee" msdata:Caption="改计划费" msprop:Generator_ColumnVarNameInTable="columnChangePlanFee" msprop:Generator_ColumnPropNameInRow="ChangePlanFee" msprop:Generator_ColumnPropNameInTable="ChangePlanFeeColumn" msprop:Generator_UserColumnName="ChangePlanFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="AgentFee" msdata:Caption="外贸代理" msprop:Generator_ColumnVarNameInTable="columnAgentFee" msprop:Generator_ColumnPropNameInRow="AgentFee" msprop:Generator_ColumnPropNameInTable="AgentFeeColumn" msprop:Generator_UserColumnName="AgentFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="TypeBillFee" msdata:Caption="打单费" msprop:Generator_ColumnVarNameInTable="columnTypeBillFee" msprop:Generator_ColumnPropNameInRow="TypeBillFee" msprop:Generator_ColumnPropNameInTable="TypeBillFeeColumn" msprop:Generator_UserColumnName="TypeBillFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="TakeBillFee" msdata:Caption="抽单费" msprop:Generator_ColumnVarNameInTable="columnTakeBillFee" msprop:Generator_ColumnPropNameInRow="TakeBillFee" msprop:Generator_ColumnPropNameInTable="TakeBillFeeColumn" msprop:Generator_UserColumnName="TakeBillFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ExpressionFee" msdata:Caption="快递费" msprop:Generator_ColumnVarNameInTable="columnExpressionFee" msprop:Generator_ColumnPropNameInRow="ExpressionFee" msprop:Generator_ColumnPropNameInTable="ExpressionFeeColumn" msprop:Generator_UserColumnName="ExpressionFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="DoneFee" msdata:Caption="搞定费" msprop:Generator_ColumnVarNameInTable="columnDoneFee" msprop:Generator_ColumnPropNameInRow="DoneFee" msprop:Generator_ColumnPropNameInTable="DoneFeeColumn" msprop:Generator_UserColumnName="DoneFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="WaitingFee" msdata:Caption="待时费" msprop:Generator_ColumnVarNameInTable="columnWaitingFee" msprop:Generator_ColumnPropNameInRow="WaitingFee" msprop:Generator_ColumnPropNameInTable="WaitingFeeColumn" msprop:Generator_UserColumnName="WaitingFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="InternalTransportFee" msdata:Caption="内贸运费" msprop:Generator_ColumnVarNameInTable="columnInternalTransportFee" msprop:Generator_ColumnPropNameInRow="InternalTransportFee" msprop:Generator_ColumnPropNameInTable="InternalTransportFeeColumn" msprop:Generator_UserColumnName="InternalTransportFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="ExchangeBoxFee" msdata:Caption="倒柜费" msprop:Generator_ColumnVarNameInTable="columnExchangeBoxFee" msprop:Generator_ColumnPropNameInRow="ExchangeBoxFee" msprop:Generator_ColumnPropNameInTable="ExchangeBoxFeeColumn" msprop:Generator_UserColumnName="ExchangeBoxFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="FairEmployeeFee" msdata:Caption="退佣" msprop:Generator_ColumnVarNameInTable="columnFairEmployeeFee" msprop:Generator_ColumnPropNameInRow="FairEmployeeFee" msprop:Generator_ColumnPropNameInTable="FairEmployeeFeeColumn" msprop:Generator_UserColumnName="FairEmployeeFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="CommissionFee" msdata:Caption="提成" msprop:Generator_ColumnVarNameInTable="columnCommissionFee" msprop:Generator_ColumnPropNameInRow="CommissionFee" msprop:Generator_ColumnPropNameInTable="CommissionFeeColumn" msprop:Generator_UserColumnName="CommissionFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="MoneyExchangeFee" msdata:Caption="外贸付汇" msprop:Generator_ColumnVarNameInTable="columnMoneyExchangeFee" msprop:Generator_ColumnPropNameInRow="MoneyExchangeFee" msprop:Generator_ColumnPropNameInTable="MoneyExchangeFeeColumn" msprop:Generator_UserColumnName="MoneyExchangeFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receiptable" msdata:Caption="合计应收" msprop:Generator_ColumnVarNameInTable="columnReceiptable" msprop:Generator_ColumnPropNameInRow="Receiptable" msprop:Generator_ColumnPropNameInTable="ReceiptableColumn" msprop:Generator_UserColumnName="Receiptable" type="xs:decimal" minOccurs="0" />
              <xs:element name="CreatedDate" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreatedBy" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" msprop:Generator_UserColumnName="CreatedBy" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" msprop:Generator_UserColumnName="ModifiedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msdata:Caption="" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" msprop:Generator_UserColumnName="ModifiedBy" type="xs:int" minOccurs="0" />
              <xs:element name="ExchangeFee2" msdata:Caption="换单费2" msprop:Generator_ColumnVarNameInTable="columnExchangeFee2" msprop:Generator_ColumnPropNameInRow="ExchangeFee2" msprop:Generator_ColumnPropNameInTable="ExchangeFee2Column" msprop:Generator_UserColumnName="ExchangeFee2" type="xs:decimal" minOccurs="0" />
              <xs:element name="ExchangeFee3" msdata:Caption="换单费3" msprop:Generator_ColumnVarNameInTable="columnExchangeFee3" msprop:Generator_ColumnPropNameInRow="ExchangeFee3" msprop:Generator_ColumnPropNameInTable="ExchangeFee3Column" msprop:Generator_UserColumnName="ExchangeFee3" type="xs:decimal" minOccurs="0" />
              <xs:element name="OtherFee" msdata:Caption="其它" msprop:Generator_ColumnVarNameInTable="columnOtherFee" msprop:Generator_ColumnPropNameInRow="OtherFee" msprop:Generator_ColumnPropNameInTable="OtherFeeColumn" msprop:Generator_UserColumnName="OtherFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="PayFee" msdata:Caption="合计应付" msprop:Generator_ColumnVarNameInTable="columnPayFee" msprop:Generator_ColumnPropNameInRow="PayFee" msprop:Generator_ColumnPropNameInTable="PayFeeColumn" msprop:Generator_UserColumnName="PayFee" type="xs:decimal" minOccurs="0" />
              <xs:element name="Profit" msdata:Caption="利润" msprop:Generator_ColumnVarNameInTable="columnProfit" msprop:Generator_ColumnPropNameInRow="Profit" msprop:Generator_ColumnPropNameInTable="ProfitColumn" msprop:Generator_UserColumnName="Profit" type="xs:decimal" minOccurs="0" />
              <xs:element name="BookingFee" msdata:Caption="订舱费" msprop:Generator_ColumnVarNameInTable="columnBookingFee" msprop:Generator_ColumnPropNameInRow="BookingFee" msprop:Generator_ColumnPropNameInTable="BookingFeeColumn" msprop:Generator_UserColumnName="BookingFee" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="CertificationFee" msdata:Caption="单证费" msprop:Generator_ColumnVarNameInTable="columnCertificationFee" msprop:Generator_ColumnPropNameInRow="CertificationFee" msprop:Generator_ColumnPropNameInTable="CertificationFeeColumn" msprop:Generator_UserColumnName="CertificationFee" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="DigitalPassFee" msdata:Caption="电放费" msprop:Generator_ColumnVarNameInTable="columnDigitalPassFee" msprop:Generator_ColumnPropNameInRow="DigitalPassFee" msprop:Generator_ColumnPropNameInTable="DigitalPassFeeColumn" msprop:Generator_UserColumnName="DigitalPassFee" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="BuyCertificationFee" msdata:Caption="买单证费" msprop:Generator_ColumnVarNameInTable="columnBuyCertificationFee" msprop:Generator_ColumnPropNameInRow="BuyCertificationFee" msprop:Generator_ColumnPropNameInTable="BuyCertificationFeeColumn" msprop:Generator_UserColumnName="BuyCertificationFee" type="xs:decimal" default="0" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="User" msprop:Generator_TableClassName="UserDataTable" msprop:Generator_TableVarName="tableUser" msprop:Generator_TablePropName="User" msprop:Generator_RowDeletingName="UserRowDeleting" msprop:Generator_UserTableName="User" msprop:Generator_RowChangingName="UserRowChanging" msprop:Generator_RowEvHandlerName="UserRowChangeEventHandler" msprop:Generator_RowDeletedName="UserRowDeleted" msprop:Generator_RowEvArgName="UserRowChangeEvent" msprop:Generator_RowChangedName="UserRowChanged" msprop:Generator_RowClassName="UserRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telephone" msprop:Generator_ColumnVarNameInTable="columnTelephone" msprop:Generator_ColumnPropNameInRow="Telephone" msprop:Generator_ColumnPropNameInTable="TelephoneColumn" msprop:Generator_UserColumnName="Telephone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cellphone" msprop:Generator_ColumnVarNameInTable="columnCellphone" msprop:Generator_ColumnPropNameInRow="Cellphone" msprop:Generator_ColumnPropNameInTable="CellphoneColumn" msprop:Generator_UserColumnName="Cellphone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QQ" msprop:Generator_ColumnVarNameInTable="columnQQ" msprop:Generator_ColumnPropNameInRow="QQ" msprop:Generator_ColumnPropNameInTable="QQColumn" msprop:Generator_UserColumnName="QQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MSN" msprop:Generator_ColumnVarNameInTable="columnMSN" msprop:Generator_ColumnPropNameInRow="MSN" msprop:Generator_ColumnPropNameInTable="MSNColumn" msprop:Generator_UserColumnName="MSN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Passsword" msprop:Generator_ColumnVarNameInTable="columnPasssword" msprop:Generator_ColumnPropNameInRow="Passsword" msprop:Generator_ColumnPropNameInTable="PassswordColumn" msprop:Generator_UserColumnName="Passsword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RoleId" msprop:Generator_ColumnVarNameInTable="columnRoleId" msprop:Generator_ColumnPropNameInRow="RoleId" msprop:Generator_ColumnPropNameInTable="RoleIdColumn" msprop:Generator_UserColumnName="RoleId" type="xs:int" minOccurs="0" />
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" msprop:Generator_UserColumnName="CreatedBy" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" msprop:Generator_UserColumnName="ModifiedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" msprop:Generator_UserColumnName="ModifiedBy" type="xs:int" minOccurs="0" />
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="RoleName" msprop:Generator_ColumnVarNameInTable="columnRoleName" msprop:Generator_ColumnPropNameInRow="RoleName" msprop:Generator_ColumnPropNameInTable="RoleNameColumn" msprop:Generator_UserColumnName="RoleName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Container_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Container" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="ImportInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ImportInfo" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Fee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Fee" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:User" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>